#!/usr/bin/env bash

sum=100

for p in `seq 3307 3400`
do
for i in `seq 1 $sum`
do
  date=$(date +%Y-%m-%d)
  echo "insert into db_backup(day, address, port, bak_type, bak_file, start_time, end_time, status) VALUES ('$date', '192.168.150.11', '$p', '物理备份', '/data/nfs/mysqlbak/bak_$p.zip', now(), now(), 0);" >> /tmp/db_backup.sql
done
done